iMIS Desktop now supports having all ANSI settings enabled at all times, which allows you to fully leverage SQL Server 2008 and to use indexed views, which improves database performance. With this change, whenever Desktop creates a connection (ODBC or otherwise), it does so with all ANSI options turned ON.
To ensure that that the entire iMIS database has the correct ANSI settings, the upgrade utility rebuilds all tables (including user-defined and third-party) and recreates all stored procedures, triggers, functions, and views. Because of this extensive one-time rebuilding, expect upgrading to be significantly slower for very large databases. Before upgrading, check that you have free disk space equal to the size of your database, as these tables will be copied during the process of conversion and rebuilding.